ManufacturerCouponFamily

Entity Definition

Logical Name : ManufacturerCouponFamily
Physical Name : CO_FMY_MF_CPN

Code assigned by the manufacturer to classify product for promotion purposes. In the ARTS model it is used to validate manufacturers coupons.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ManufacturerID (FK)(PK) A unique system assigned identifier for the Manufacturer. ID_MF Identity integer Manufacturer(PA_MF)
ManufacturerFamilyCode (PK) The UPC designated three digit coupon family code for the manufacturer item. FC_FMY_MF ProductCodeFamily char(3)
CouponTypeCode (FK) A code to denote the type of coupon, e.g. raincheck, manufacturer coupon, electronic coupon. TY_CPN Code2 char(2) CouponHandlingRule(RU_HN_CPN)
Description The description for a coupon family code for the manufacturer item. DE_FMY_MF DescriptionShort varchar(255)
DispositionCode A mnemonic code denoting what is to happen to the Coupons after they have been tendered. e.g. Remit to Issuer, Store, Discard. DP_FMY_MF_CPN Code4 char(4)
ManufacturerCouponFamilyName The name for a coupon family code for the manufacturer item. NM_FMY_MF_CPN Name varchar(40)

Relationships

Parent Entity Verb Phrase Child Entity
CouponHandlingRule refers to ManufacturerCouponFamily
Manufacturer defines ManufacturerCouponFamily
ManufacturerCouponFamily is part of ItemSellingRule
ManufacturerCouponFamily validates CouponTenderLineItem

Logical Views containing ManufacturerCouponFamily

Logical View
Logical 01100 - Item Selling Rules - Macro View
Logical 01120 - Item Selling Rules - Manufacturer Coupon View
Logical 02333 - Retail Transaction - Tender - Coupon View